package com.xsh.gls.mapper;

import com.xsh.gls.pojo.Order;
import org.apache.ibatis.annotations.Param;

import java.math.BigDecimal;
import java.util.Date;
import java.util.List;

public interface OrderMapper {
    int deleteByPrimaryKey(BigDecimal id);

    int insert(Order record);
    //下单方法
    int insertSelective(Order record);

    List<Order> selectByPrimaryKey(@Param("orderNumber") String orderNumber);

    int updateByPrimaryKeySelective(Order record);

    int updateByPrimaryKey(Order record);

    List<Order> selectByOrderNo(@Param("orderNo") String orderNo);

    List<Order> getByAll(@Param("spelno") Integer spelno,
                           @Param("orderNumber")String orderNumber, @Param("reqNo") String reqNo,
                           @Param("SONO")Integer sono,@Param("shippingType")Integer shippingType);



    Order getByOrderNo(@Param("orderNumber") String orderNumber);

    List<Order> orderSelectByOwn(@Param("orderNumber")String orderNumber,@Param("CusId")int CusId);

    int updateDeclareImgById(Order order);
    int updateInsureImgById(Order order);

    int updateByBookingno(Order record);


    int updateByorderNumber(Order order);

    List<Order> getOrderAll(@Param("orderNumber")String orderNumber,@Param("bookingid")Integer bookingid,
                            @Param("statusid")Integer statusid,@Param("exportorgname")String exportorgname,
                            @Param("salesmanid")Integer salesmanid,@Param("customerName")String customerName);


    int updateByspelnos(int spelno);

    List<Integer> getByspelnos(int spelno);

    Order getByNewOrderNo(@Param("orderNumber")String orderNumber);



    List<Order> selectByOrNo(@Param("orderNumber") String orderNo);

    List<Order> selectByNo(@Param("orderNumber") String orderNo,@Param("salesmanid") Integer salId);

    Order selectByN(@Param("id") Integer id);

    Order queryOrderById(Integer id);

    int finshUpdate(Order order);

    List<Order>  queryOrderByEare(Order order);


    int updateByLWOrderNo(String orderNumber);

    List<String> getByLWOrderNo(String orderNumber);

    int updatechuku(Order order);

    int updateruku(Order order);



    List<Order> orderCenter(Order order);

    int update(Order order);

    Order selectByPay(String orderNumber);

    int updateJiedan(Order order);

    int updatepay(String  orderNumber);
List<Order> selectecharts(@Param("exportorgname") String finshtime);
}